2013-10-18 - 9591.100 - Spec - Rewrite BI FI Reports to use New Query #CrystalReportDevelopment
SPECIFICATIONS
9591.100 - Rewrite BI FI Reports to use New Query
Requirement Summary
Rewrite FI100, FI110, FI113, FI115, FI116 and FI120 to use new Query like FI100 and FI112 and also change FI112 to use the new query in one of its sub-reports.
Admin Info
Purpose
|
Need to rewrite BI FI Reports to use New Query
|
Requested By
|
Lori Miterko
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
10/18/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
FI Production reports
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
Below are the list of reports that we need to change the source to use new query as per the table below:
SNo
|
Report Name
|
Old Query
|
New Query
|
1.
|
FI100 - Consolidated Income Statement
|
ZMP_GLPC_Q001
|
ZMP_GLPC_Q004
|
2.
|
FI110 - Income Statement
|
ZMP_GLPC_Q001
|
ZMP_GLPC_Q004
|
3.
|
FI112 - Income Statement with Last Year
|
ZMP_GLPC_Q004
ZMP_GLPC_Q001
|
ZMP_GLPC_Q004
ZMP_GLPC_Q004
|
4.
|
FI113 - Income Statement with Last Year Actuals Only
|
ZMP_GLPC_Q001
|
ZMP_GLPC_Q004
|
5.
|
FI115 - Income Statement with Details
|
ZMP_GLPC_Q006
|
ZMP_GLPC_Q008
|
6.
|
FI116 - Income Statement with Detail by Period
|
ZMP_GLPC_Q006
|
ZMP_GLPC_Q008
|
7.
|
FI120 - Income Statement in company currency
|
ZMP_GLPC_Q003
|
ZMP_GLPC_Q009
|
Solution Summary
1. Need to update the Crystal Report sources to new query.
2. Need to map the unmapped fields in the designer.
3. Need to map the Structure field to Company Code Key figure.
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1.
|
Report Format
|
As per NEC standards
|
2.
|
Execute Crystal Report in Crystal Designer tool after changes
|
Report should execute successfully in Crystal Designer tool
|
3.
|
Scheduling the Report in NEC BI Launch Pad
|
Report should execute successfully in NEC BI Launch Pad
|
Solution Details
1. Need to update the Crystal Report source to new query.
2. Need to map the unmapped fields in the designer.
3. Need to map the Structure field to Company Code Key figure.
4. Need to change the formulas to show the correct values.
5. Need to comment the unused logic in the record selection as well in the respective formulas.
6. Need to fix the issues and schedule in the development server.
Issues
None
Report Name
|
Location
|
Status
|
FI100 - Consolidated Income Statement
|
IT > BMS > Production
|
Moved to Production
|
FI110 - Income Statement
|
IT > BMS > Production
|
Done
|
FI112 - Income Statement with Last Year
|
IT > BMS > Production
|
Done
|
FI113 - Income Statement with Last Year Actuals Only
|
IT > BMS > Production
|
Done
|
FI115 - Income Statement with Details
|
IT > BMS > Production
|
Done
|
FI116 - Income Statement with Detail by Period
|
IT > BMS > Production
|
Done
|
FI120 - Income Statement in company currency
|
IT > BMS > Production
|
Done
|